package com.ml.mall.mapper;

import com.ml.mall.entity.sys.SysSubscription;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * @Entity com.ml.mall.entity.sys.SysSubscription
 */
@Mapper
@Repository
public interface SysSubscriptionMapper extends BaseMapper<SysSubscription> {

    @Select("select min(id) from sys_subscription where role_type = #{roleType}")
    Long selectMinIdByRoleType(@Param("roleType") Integer roleType);
}




